package com.examination.system.instructor.dao.mysql;

import org.apache.ibatis.builder.annotation.ProviderContext;
import org.apache.ibatis.jdbc.SQL;


/**
 * @author 寇淇芮
 * @Date 2019/11/6 15:08
 */
public class TbStudentEssentialSqlTool {
    public String selectJsonById(final String id,final ProviderContext providerContext){
         return  new SQL(){{
             SELECT("a.*,n.nation");
             FROM("tb_Studentessential as a");
             LEFT_OUTER_JOIN("nation as n on a.national = n.id");
             WHERE("a.id = #{id}");
         }}.toString();
    }
}
